ICDMerchandiseSerializedUnit

Entity Definition

Logical Name : ICDMerchandiseSerializedUnit
Physical Name : DO_LTM_ICD_MR_SRZ

A modifier that records the serial number of an individualized StockItem or Batch of items that was received or transferred on an ICDMerchandiseLineItem.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
SerialNumber (FK)(PK) A unique code, which can be either alpha, numeric or alpha-numeric, to identify an individual ITEM. ID_NMB_SRZ Name varchar(40) SerializedUnit(AS_UN_SRZ)
ItemID (FK)(PK) A unique system assigned identifier for the retailer's SKU. ID_ITM IdentityUUID char(32) SerializedUnit(AS_UN_SRZ)
InventoryControlDocumentID (FK) The reference number that uniquely identifies the InventoryControlDocument. ID_ICD Identity integer ICDMerchandiseLineItem(DO_LTM_ICD_MR)
InventoryControlDocumentLineItemID (FK) A unique system assigned identifier for the LineItem within the confines of the InventoryControlDocument. IC_LTM_ICD LineNumber smallint ICDMerchandiseLineItem(DO_LTM_ICD_MR)

Relationships

Parent Entity Verb Phrase Child Entity
SerializedUnit is received via ICDMerchandiseSerializedUnit
ICDMerchandiseLineItem is transferred/ordered/received via ICDMerchandiseSerializedUnit

No Logical Views for ICDMerchandiseSerializedUnit